Some time ago, the project involved the conversion between MySQL and MSSQL data types. Recently, I was studying Sina Weibo's API, which involved the conversion of GMT time types with time zones, this is a special record for future query.
I.
1.UTC Time and GMT time
We can think of GMT as time Coordination Time (GMT=UTC), GMT and UTC time are calculated in seconds.
2.UTC Time and Local
UTC + time Zone difference = local time
Time zone Chadong is positive, West is negative. Here, the
Origin of the problemTimestamp conversion (timestamp: The total number of seconds from January 1, 1970 (00:00:00) to the current time. )#include #includeintMainintargcConst Char*argv[]) {time_t T; structTM *p; T=1408413451; P=gmtime (&t); Chars[
Problem: the system time is different from the database time. the system time is, and the time saved to the database is.
The first intuition is caused by different time zones.
First look at a piece of code:
Java code
Public static void main
Convert js timestamp to date format. Convert js timestamp to date format.
Unix timestamp: Unix timestamp, or Unix time, POSIX time ), it is a time representation, which is defined as the total number of seconds from January 1, January 01, 1970 to
: This article mainly introduces that the GMT + 8 string of the PHP conversion database is the user's local time zone. if you are interested in the PHP Tutorial, refer to it.
Write user time zone into cookie
Php reads and processes user time
In the use of the Vertica database, a scenario is encountered in which the program collects data from the cluster in the same area and writes the same table, and then we need to display the data in GMT time. At this point we can provide the time
JS gets the Unix time stamp
The Unix timestamp (Unix timestamp), or Unix time (Unix times), POSIX time (POSIX times), is a time representation, defined as the total number of seconds from GMT January 01, 1970 00:00 00 seconds to the present. Unix
A UNIX timestamp is a compact and concise way to save dates and times, a way to save the current date and time in most Unix systems, and a standard format for representing dates and times in most computer languages. Represents Greenwich Mean Time in
Time (converted from timestamp to timestamp)
Public class Date_U {/*** drop this method and enter the time to be converted, for example, ("June 14, 2014 seconds ") return timestamp ** @ param time * @ return */public String data (String time)
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.